﻿IF object_id(N'dbo.UDS_CM_ClientContact_Cooperatingman', 'U') IS NULL
BEGIN
    CREATE TABLE [dbo].[UDS_CM_ClientContact_Cooperatingman] (
        [ID]               int NOT NULL identity(1, 1),
        [ContactID]        int NULL,
        [CooperatingmanID] int NULL,

        CONSTRAINT [PK_UDS_CM_ClientContact_Cooperatingman] PRIMARY KEY CLUSTERED ([ID] asc),
        CONSTRAINT [FK_UDS_CM_ClientContact_Cooperatingman_UDS_CM_ClientContact] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[UDS_CM_ClientContact] ([ID]),
        CONSTRAINT [FK_UDS_CM_ClientContact_Cooperatingman_UDS_Staff] FOREIGN KEY ([CooperatingmanID]) REFERENCES [dbo].[UDS_Staff] ([Staff_ID]) ON UPDATE CASCADE
    );
END
GO
